Local name configuration: The local name can access the required database or server information with a simple name, and the information is saved to tnsnames. ora.
LOCALNAME: local nameADDRESS: server ADDRESSPROTOCOL: PROTOCOL usedHOST: IP
Three configuration files Listener. ora, sqlnet. ora, and tnsnames. ora are all stored in the $ ORACLE_HOME \ network \ admin directory. -- Begin focus: Roles and usage of the three files #-----------------------Sqlnet. ora (client and server) --
Http://blog.sina.com.cn/s/blog_44f8b6a40100ah97.html
Sqlnet. ora, tnsnames. ora, and listener. ora files used for Oracle Network ConfigurationNote:ArticleThe content is organized by the Internet and related books, so it is only for sharing
Http://hi.baidu.com/easydba/blog/item/9ccbae890bca04b60f2444c3.html
Listener. ora, sqlnet. ora, and tnsnames. ora are all stored in the $ ORACLE_HOME/Network/Admin directory. Key points: Functions and usage of the three files #-----------------
Listener. ora, tnsnames. ora, and sqlnet. ora are the three main files related to Oracle network configuration. They are all stored in the $ ORACLE_HOME \ Network \ ADMIN directory. Listener. ora is related to the database server, while tnsnames.
Oracle Network ConfigurationThe listener. ora, sqlnet. ora, and tnsnames. ora configuration files are all stored in the $ ORACLE_HOME/network/admin directory.
English description:
The sqlnet. ora is an optional file expressing more parameters about
OverviewIn the Oracle installation directory $ home/Network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many people.Sqlnet. ora is used
The listener. ora, sqlnet. ora, and tnsnames. ora configuration files are stored in the $ ORACLE_HOME \ network \ admin directory. 1. sqlnet. ora ----- is similar to the nsswitch. conf file of linux or other unix. It is used to determine how to find
For listeners that are not on the default port (1521), The pmon process does not register the service/instance to the listener, that is, dynamic registration is not implemented. Similar to a single instance, listeners with non-default RAC ports also
Oracle: listener. ora, sqlnet. ora, tnsnames. ora configuration and example1. Solve the problem: TNS or the database cannot log on.The simplest and most effective method: use the tool netca provided by the Oracle System to configure (delete the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.